<?php

class SickhrsController extends Controller {

    /**
     * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
     * using two-column layout. See 'protected/views/layouts/column2.php'.
     */
    public $layout = '//layouts/column2';
    public $employee;

    /**
     * @return array action filters
     */
    public function filters() {
        return array(
            'accessControl', // perform access control for CRUD operations
        );
    }

    /**
     * Specifies the access control rules.
     * This method is used by the 'accessControl' filter.
     * @return array access control rules
     */
    public function accessRules() {
        return array(
            array('allow', // allow all users to perform 'index' and 'view' actions			
               'users'=>array('@'),
            ),
            array('deny', // deny all users
                'users' => array('*'),
            ),
        );
    }

    /**
     * Creates a new model.
     * If creation is successful, the browser will be redirected to the 'view' page.
     */
    public function actionCreate($empno) {
        $model = new Sickhrs;
        $model->empno = $empno;
        $this->loadEmployee($empno);
        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);
$_POST['Sickhrs']['hours'] = $_POST['hours'];
$_POST['Sickhrs']['notes'] = $_POST['notes'];
$_POST['Sickhrs']['datetaken'] = $_POST['datetaken'];
$_POST['Sickhrs']['addedby'] = $_POST['addedby'];
        if (isset($_POST['Sickhrs'])) {
            $model->attributes = $_POST['Sickhrs'];
            if ($model->save())
                $this->redirect(array('index', 'empno' => $empno));
        }

        $this->render('create', array(
            'model' => $model,
            'employee' => $this->employee
        ));
    }

    /**
     * Updates a particular model.
     * If update is successful, the browser will be redirected to the 'view' page.
     * @param integer $id the ID of the model to be updated
     */
    public function actionUpdate($id) {
        $model = $this->loadModel($id);
        $this->loadEmployee($model->empno);
        // Uncomment the following line if AJAX validation is needed
        // $this->performAjaxValidation($model);
$_POST['Sickhrs']['hours'] = $_POST['hours'];
$_POST['Sickhrs']['notes'] = $_POST['notes'];
$_POST['Sickhrs']['datetaken'] = $_POST['datetaken'];
$_POST['Sickhrs']['addedby'] = $_POST['addedby'];
        if (isset($_POST['Sickhrs'])) {
            $model->attributes = $_POST['Sickhrs'];
            if ($model->save())
                $this->redirect(array('index', 'empno' => $model->empno));
        }

        $this->render('create', array(
            'model' => $model,
            'employee' => $this->employee
        ));
    }

    /**
     * Deletes a particular model.
     * If deletion is successful, the browser will be redirected to the 'admin' page.
     * @param integer $id the ID of the model to be deleted
     */
    public function actionDelete($id) {
        // we only allow deletion via POST request
        $model=$this->loadModel($id);
        $empno=$model->empno;
        $model->delete();
        
        // if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
        if (!isset($_GET['ajax']))
            $this->redirect(array('index','empno'=>$empno));
    }

    /**
     * Lists all models.
     */
    public function actionIndex($empno) {
        $this->loadEmployee($empno);

        $this->render('index', array(
            'employee' => $this->employee,
        ));
    }

    /**
     * Returns the data model based on the primary key given in the GET variable.
     * If the data model is not found, an HTTP exception will be raised.
     * @param integer the ID of the model to be loaded
     */
    public function loadModel($id) {
        $model = Sickhrs::model()->findByPk($id);
        if ($model === null)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $model;
    }

    /**
     * Performs the AJAX validation.
     * @param CModel the model to be validated
     */
    protected function performAjaxValidation($model) {
        if (isset($_POST['ajax']) && $_POST['ajax'] === 'sickhrs-form') {
            echo CActiveForm::validate($model);
            Yii::app()->end();
        }
    }

    public function actionList($empno, $page=0, $sort=NULL) {
        if ($page > 0)
            $page--;

        $order = CJSON::decode($sort);
        $data = new CActiveDataProvider('Sickhrs', array(
                    'criteria' => array(
                        'condition' => 'empno=:empno',
                        'params' => array(
                            'empno' => $empno
                        ),
                        'order' => isset($sort) ? $order[0]['property'] . ' ' . $order[0]['direction'] : NULL,
                    ),
                    'pagination' => array(
                        'pageSize' => 20,
                        'currentPage' => $page
                    )
                ));
        if ($data != NULL && count($data->getData()) > 0) {
            $rs = array();
            $rs['totalCount'] = $data->getTotalItemCount();
            foreach ($data->getData() as $i => $item) {
                $rs['data'][$i] = $item->getAttributes();
                $rs['data'][$i]['addedby']=getUserRealname($item->addedby);
            }
            echo json_encode($rs);
        }
        Yii::app()->end();
    }

    public function loadEmployee($empno) {
        $this->employee = Employees::model()->findByPk($empno);
        if ($this->employee == NULL)
            throw new CHttpException(404, 'The requested page does not exist.');
        return $this->employee;
    }

}
